<?php
require_once("../conexion/conexion.php");


extract($_POST);
//echo "valor= ".$cmb_AExtraccion;
?> 

<select name="cmb_Region" id="cmb_Region">
      <?php 
	  $con = new Conexion();
	  $con2 = $con->conexionBD("fpproduccion");
	  $sql="select region.RegCod,RegNombre from region inner join areaextraccion on region.RegCod=areaextraccion.RegCod where AECod='".$cmb_AExtraccion."' ";
      $res= mysql_query($sql) or die ($con->error_mysql("Error en la consulta".mysql_error()));
	  while($reg = mysql_fetch_array($res))
	  {
	  	echo '<option value="'.$reg["0"].'">'.$reg["1"].'</option>';
	  } 
	  ?>
	  
	  $con->cerrarBD();
</select>	  